package com.jash.labor.mapper.provider;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Select;
import org.springframework.util.StringUtils;

public class SqlProvider {
    public String laborQueryStationList(Page page, String content){
        String sql = "select f.name fname,salary_start,salary_end,s.name sname, \n" +
                "recr_time_start,recr_time_end,rest_time_start,rest_time_end,\n" +
                "insurance,nums,accommodation,contact,mobile,referral_fee \n" +
                "from first_party f,station s,company c \n" +
                "where f.company_id = c.id and f.id = s.first_party_id \n" +
                "and (s.name like '%"+content+"%' or " +
                "(salary_start <= '"+content+"' and salary_end >='"+content+"')) \n";
        sql += "order by s.id desc";
        return sql;
    }
}
